---
title: Manage case consolidation
summary: Link one legal case to another as a consolidated case, cascading a case-status update.
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
operation_id: OP-CLL-011
trigger: User consolidates two or more legal cases
---

# Manage case consolidation

Link one legal case to another as a consolidated case, cascading a case-status update.

| Field | Value |
|---|---|
| **Operation ID** | OP-CLL-011 |
| **Trigger** | User consolidates two or more legal cases |
| **Inputs** | Business-object criteria properties set by the caller (see linked SQL parameter tables) |
| **Outputs** | Persisted/retrieved `clsConsolidations` state |
| **Primary components** | `clsConsolidations` |
| **Entry point** | `SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb` |

## Steps

1. Validate the request against applicable business rules: [BR-CLM-LGL-025](../business-rules.md#br-clm-lgl-025-consolidation-schedule-non-production-behavior-suppression)
   - On failure: validation errors are collected and returned to the caller; the operation does not proceed.
2. Execute the underlying data access for `clsConsolidations` against: [DB-CLL-056](../sql/SQL-056-consolidations.md), [DB-CLL-057](../sql/SQL-057-consolidations.md)
   - Tables affected: [CONSOLIDATED_CASE](../database-tables.md#consolidated_case), [LEGAL_CASE](../database-tables.md#legal_case), [CASE_STATUS_HISTORY](../database-tables.md#case_status_history)
3. Return the resulting object graph (or success/failure status) to the caller.

## Process flow

```mermaid
flowchart TD
	Start([User consolidates two or more legal cases]) --> Validate[Validate business rules]
	Validate --> Decision{Valid?}
	Decision -->|No| EndErr([Return validation errors])
	Decision -->|Yes| Exec[Execute data access for clsConsolidations]
	Exec --> EndOk([Return result])
```

## Failure and edge-case behavior

- Validation failure: the operation returns collected errors without persisting any change.

## Related documentation
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [SQL catalog](../sql/index.md)
- [Database tables](../database-tables.md)

## Sources
- `SAIF.Business.Claim.Legal\` (clsConsolidations)